-- Deletes the specified document (and potentially all child documents if the document is involved
-- in a hierarchy).  
CREATE PROCEDURE [dbo].[asi_DocumentDelete]
    @documentVersionKey uniqueidentifier,
    @purgeVersions bit = 0
AS
BEGIN
    SET NOCOUNT ON
    DECLARE @hierarchyKey uniqueidentifier

    -- Get the hierarchy key
    SELECT @hierarchyKey = HierarchyKey FROM [dbo].[Hierarchy]
     WHERE UniformKey = @documentVersionKey

    IF (@hierarchyKey IS NOT NULL)
        EXEC [dbo].[asi_DocumentDeleteHierarchy] @hierarchyKey, @purgeVersions
    EXEC [dbo].[asi_DocumentDeleteDocument] @documentVersionKey, @purgeVersions
    SET NOCOUNT OFF
END

GO